{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "372b1c79",
   "metadata": {},
   "source": [
    "## 地理/逆地理编码\n",
    "* 结构化地址:\n",
    "* 首先，地址肯定是一串字符，内含国家、省份、城市、区县、城镇、乡村、街道、门牌号码、屋邨、大厦等建筑物名称。按照由大区域名称到小区域名称组合在一起的字符。一个有效的地址应该是独一无二的。注意：针对大陆、港、澳地区的地理编码转换时可以将国家信息选择性的忽略，但省、市、城镇等级别的地址构成是不能忽略的。暂时不支持返回台湾省的详细地址信息。\n",
    "\n",
    "* 结构化地址<--->经纬度\n",
    "* 地理编码/逆地理编码 API 是通过 HTTP/HTTPS 协议访问远程服务的接口，提供结构化地址与经纬度之间的相互转化的能力"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "cf783f5e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1. 调用requests模块（google chrome 浏览器）\n",
    "import requests\n",
    "# 2. 请求方法 ： GET\n",
    "# 3. URL地址 ： https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "# 4. 准备参数，用于交换数据 payload\n",
    "payload = {\n",
    "    \"key\":\"17ceaab8de5fd9472eb40a8cfdbdce5e\",\n",
    "    \"address\":\"广东省广州市从化区广州南方学院\"\n",
    "}\n",
    "# 5. 发起请求\n",
    "r = requests.get(url=geo_url, params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "3880be18",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "d948dff7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省广州市从化区温泉镇中心大学南方学院',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '020',\n",
       "   'city': '广州市',\n",
       "   'district': '从化区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '440117',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '113.678280,23.628439',\n",
       "   'level': '兴趣点'}]}"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "9d545774",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州南方学院_location = r.json()['geocodes'][0]['location']\n",
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "487bd473",
   "metadata": {},
   "source": [
    "## 逆地理编码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "a2132d46",
   "metadata": {},
   "outputs": [],
   "source": [
    "# extensions=base（默认）\n",
    "# 1. 调用requests模块（google chrome 浏览器）\n",
    "import requests\n",
    "# 2. 请求方法 ： GET\n",
    "# 3. URL地址 ： https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "regeo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "# 4. 准备参数，用于交换数据 payload\n",
    "payload = {\n",
    "    \"key\":\"17ceaab8de5fd9472eb40a8cfdbdce5e\",\n",
    "    \"location\":广州南方学院_location\n",
    "}\n",
    "# 5. 发起请求\n",
    "r = requests.get(url=regeo_url, params=payload)   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "161e3e3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "cbe46afd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'regeocode': {'addressComponent': {'city': '广州市',\n",
       "   'province': '广东省',\n",
       "   'adcode': '440117',\n",
       "   'district': '从化区',\n",
       "   'towncode': '440117100000',\n",
       "   'streetNumber': {'number': '24号',\n",
       "    'location': '113.677267,23.629149',\n",
       "    'direction': '西北',\n",
       "    'distance': '129.943',\n",
       "    'street': '博学路'},\n",
       "   'country': '中国',\n",
       "   'township': '温泉镇',\n",
       "   'businessAreas': [[]],\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'citycode': '020'},\n",
       "  'formatted_address': '广东省广州市从化区温泉镇博学路广州南方学院'},\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000'}"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "5f6c5ab0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# extensions=all \n",
    "# 1. 调用requests模块（google chrome 浏览器）\n",
    "import requests\n",
    "# 2. 请求方法 ： GET\n",
    "# 3. URL地址 ： https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "regeo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "# 4. 准备参数，用于交换数据 payload\n",
    "payload = {\n",
    "    \"key\":\"17ceaab8de5fd9472eb40a8cfdbdce5e\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"extensions\":\"all\",\n",
    "    \"poitype\":\"true\",\n",
    "    \n",
    "    \n",
    "}\n",
    "# 5. 发起请求\n",
    "r = requests.get(url=regeo_url, params=payload) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "970a400a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "e19a0b42",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区温泉镇博学路广州南方学院',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '温泉镇',\n",
       "   'towncode': '440117100000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '博学路',\n",
       "    'number': '24号',\n",
       "    'location': '113.677267,23.629149',\n",
       "    'direction': '西北',\n",
       "    'distance': '129.943'},\n",
       "   'businessAreas': [[]]},\n",
       "  'pois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': '020-87828988;020-61787331',\n",
       "    'direction': '北',\n",
       "    'distance': '470.792',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.450402',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG4TAF2',\n",
       "    'name': '广州南方公寓',\n",
       "    'type': '商务住宅;商务住宅相关;商务住宅相关',\n",
       "    'tel': '13622768437',\n",
       "    'direction': '东南',\n",
       "    'distance': '102.617',\n",
       "    'location': '113.678983,23.627778',\n",
       "    'address': '温泉镇乌土村松浪队5号(近博学路)',\n",
       "    'poiweight': '0.237309',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H6FA18J5',\n",
       "    'name': '保利半山花园',\n",
       "    'type': '商务住宅;住宅区;住宅区',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '139.054',\n",
       "    'location': '113.679358,23.627672',\n",
       "    'address': '从莞深高速(广州南方学院南侧)',\n",
       "    'poiweight': '0.223065',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B00140TWHT',\n",
       "    'name': '教工住宅1号',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '222.658',\n",
       "    'location': '113.678490,23.630432',\n",
       "    'address': '笃行路2',\n",
       "    'poiweight': '0.157653',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHRJDM9',\n",
       "    'name': '中南公寓',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': '13711245345',\n",
       "    'direction': '东南',\n",
       "    'distance': '231.223',\n",
       "    'location': '113.680340,23.627566',\n",
       "    'address': '中大南方学院南门1号',\n",
       "    'poiweight': '0.256152',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD588HJ',\n",
       "    'name': '广州南方学院教学楼4号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '242.901',\n",
       "    'location': '113.677460,23.630490',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHZH0IK',\n",
       "    'name': '地下铁',\n",
       "    'type': '餐饮服务;冷饮店;冷饮店',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '74.1376',\n",
       "    'location': '113.677941,23.629029',\n",
       "    'address': '博学路广州南方学院综合楼内',\n",
       "    'poiweight': '0.17934',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU76L2',\n",
       "    'name': '广州南方学院2号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '280.003',\n",
       "    'location': '113.678211,23.630956',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP838K',\n",
       "    'name': '教学楼3号(外国语学院)',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '298.093',\n",
       "    'location': '113.677247,23.630947',\n",
       "    'address': '博学路25',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKSF1FI',\n",
       "    'name': '香辣螺蛳粉',\n",
       "    'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "    'tel': '17820061022',\n",
       "    'direction': '西',\n",
       "    'distance': '209.206',\n",
       "    'location': '113.676231,23.628565',\n",
       "    'address': '广州南方学院西4123',\n",
       "    'poiweight': '0.209252',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU8NLD',\n",
       "    'name': '广州南方学院1号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '326.007',\n",
       "    'location': '113.678215,23.631370',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLF90I2',\n",
       "    'name': '煌上煌酱鸭(南方学院店)',\n",
       "    'type': '餐饮服务;快餐厅;快餐厅',\n",
       "    'tel': '13712317721',\n",
       "    'direction': '东北',\n",
       "    'distance': '256.772',\n",
       "    'location': '113.679965,23.630156',\n",
       "    'address': '笃行路20、22、24号广州南方学院商业中心1层1F015',\n",
       "    'poiweight': '0.209448',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58UTU',\n",
       "    'name': '广州南方学院2号教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '346.352',\n",
       "    'location': '113.677060,23.631346',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H25SMRKP',\n",
       "    'name': '广州南方学院大礼堂',\n",
       "    'type': '科教文化服务;会展中心;会展中心',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '386.65',\n",
       "    'location': '113.680076,23.631502',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.261624',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JD',\n",
       "    'name': '广州南方学院教学楼1号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '391.548',\n",
       "    'location': '113.677077,23.631783',\n",
       "    'address': '博学路19号',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD592BJ',\n",
       "    'name': '广州南方学院综合楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '392.731',\n",
       "    'location': '113.680117,23.631544',\n",
       "    'address': '温泉大道886号广州南方学院内',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP81F0',\n",
       "    'name': '教学楼1号(文学与传媒学院)',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '393.93',\n",
       "    'location': '113.676866,23.631736',\n",
       "    'address': '博学路19号附近',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLBEOND',\n",
       "    'name': '聚贤楼10号',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '418.51',\n",
       "    'location': '113.681253,23.631036',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.190963',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFH6K3U9',\n",
       "    'name': '广州中大南方招待所',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '020-61787222',\n",
       "    'direction': '西北',\n",
       "    'distance': '378.102',\n",
       "    'location': '113.676330,23.631332',\n",
       "    'address': '温泉镇温泉大道882号广州南方学院H7栋1-5层',\n",
       "    'poiweight': '0.254885',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58NF8',\n",
       "    'name': '广州南方学院达人书院',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '446.366',\n",
       "    'location': '113.679041,23.632392',\n",
       "    'address': '温泉大道882号广州南方学院新综合楼2层',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKUVYWV',\n",
       "    'name': '广州和风庭阿七度假别墅',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '424.35',\n",
       "    'location': '113.681736,23.630569',\n",
       "    'address': '保利桃花源',\n",
       "    'poiweight': '0.273168',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU99RM',\n",
       "    'name': '广州南方学院图书馆',\n",
       "    'type': '科教文化服务;图书馆;图书馆',\n",
       "    'tel': '020-61787368;020-61787371',\n",
       "    'direction': '北',\n",
       "    'distance': '489.331',\n",
       "    'location': '113.679177,23.632762',\n",
       "    'address': '温泉大道882号广州南方学院内',\n",
       "    'poiweight': '0.257947',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JC',\n",
       "    'name': '广州南方学院4号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '498.883',\n",
       "    'location': '113.679963,23.632652',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFL7C054',\n",
       "    'name': '广州U优森特酒店',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '15813395296',\n",
       "    'direction': '北',\n",
       "    'distance': '464.819',\n",
       "    'location': '113.679226,23.632528',\n",
       "    'address': '温泉镇博学路882号(广州南方学院商业中心1层)',\n",
       "    'poiweight': '0.317505',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG8CSEK',\n",
       "    'name': 'L5员工宿舍',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '554.129',\n",
       "    'location': '113.682583,23.631487',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.185371',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58FR2',\n",
       "    'name': '广州南方学院教学楼9号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '532.163',\n",
       "    'location': '113.679747,23.633032',\n",
       "    'address': '广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HG5Z9JNK',\n",
       "    'name': '广州南方学院教学楼7号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '544.868',\n",
       "    'location': '113.678600,23.633330',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221553',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD599JM',\n",
       "    'name': '广州南方学院第11教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '556.036',\n",
       "    'location': '113.680037,23.633173',\n",
       "    'address': '温泉大道882号广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0GUJYPEG2',\n",
       "    'name': '怒烤烤串(从化店)',\n",
       "    'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '510.112',\n",
       "    'location': '113.677160,23.632910',\n",
       "    'address': '温泉大道882号广州南方学院内博学路6号之3',\n",
       "    'poiweight': '0.216026',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU6Z41',\n",
       "    'name': '广州南方学院教学楼6号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '586.331',\n",
       "    'location': '113.678424,23.633710',\n",
       "    'address': '温泉大道882',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []}],\n",
       "  'roads': [{'id': '020F49F0050461206',\n",
       "    'name': '博学路',\n",
       "    'direction': '北',\n",
       "    'distance': '7.63232',\n",
       "    'location': '113.678,23.6284'},\n",
       "   {'id': '020F49F0050462229',\n",
       "    'name': '老虎形街',\n",
       "    'direction': '北',\n",
       "    'distance': '445.159',\n",
       "    'location': '113.679,23.6245'},\n",
       "   {'id': '020F49F0050462451',\n",
       "    'name': '中山路',\n",
       "    'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.677,23.6347'}],\n",
       "  'roadinters': [{'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.676794,23.634661',\n",
       "    'first_id': '020F49F0050461206',\n",
       "    'first_name': '博学路',\n",
       "    'second_id': '020F49F0050462451',\n",
       "    'second_name': '中山路'}],\n",
       "  'aois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'adcode': '440117',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'area': '528560.656426',\n",
       "    'distance': '0',\n",
       "    'type': '141201'}]}}"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "60193a42",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "e4d42e03",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>tel</th>\n",
       "      <th>direction</th>\n",
       "      <th>distance</th>\n",
       "      <th>location</th>\n",
       "      <th>address</th>\n",
       "      <th>poiweight</th>\n",
       "      <th>businessarea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B00140MR9A</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>科教文化服务;学校;高等院校</td>\n",
       "      <td>020-87828988;020-61787331</td>\n",
       "      <td>北</td>\n",
       "      <td>470.792</td>\n",
       "      <td>113.679257,23.632577</td>\n",
       "      <td>温泉大道882号</td>\n",
       "      <td>0.450402</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B0FFG4TAF2</td>\n",
       "      <td>广州南方公寓</td>\n",
       "      <td>商务住宅;商务住宅相关;商务住宅相关</td>\n",
       "      <td>13622768437</td>\n",
       "      <td>东南</td>\n",
       "      <td>102.617</td>\n",
       "      <td>113.678983,23.627778</td>\n",
       "      <td>温泉镇乌土村松浪队5号(近博学路)</td>\n",
       "      <td>0.237309</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B0H6FA18J5</td>\n",
       "      <td>保利半山花园</td>\n",
       "      <td>商务住宅;住宅区;住宅区</td>\n",
       "      <td>[]</td>\n",
       "      <td>东南</td>\n",
       "      <td>139.054</td>\n",
       "      <td>113.679358,23.627672</td>\n",
       "      <td>从莞深高速(广州南方学院南侧)</td>\n",
       "      <td>0.223065</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B00140TWHT</td>\n",
       "      <td>教工住宅1号</td>\n",
       "      <td>商务住宅;住宅区;住宅小区</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>222.658</td>\n",
       "      <td>113.678490,23.630432</td>\n",
       "      <td>笃行路2</td>\n",
       "      <td>0.157653</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B0FFHRJDM9</td>\n",
       "      <td>中南公寓</td>\n",
       "      <td>商务住宅;住宅区;住宅小区</td>\n",
       "      <td>13711245345</td>\n",
       "      <td>东南</td>\n",
       "      <td>231.223</td>\n",
       "      <td>113.680340,23.627566</td>\n",
       "      <td>中大南方学院南门1号</td>\n",
       "      <td>0.256152</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B0HGD588HJ</td>\n",
       "      <td>广州南方学院教学楼4号</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>242.901</td>\n",
       "      <td>113.677460,23.630490</td>\n",
       "      <td>博学路</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>B0FFHZH0IK</td>\n",
       "      <td>地下铁</td>\n",
       "      <td>餐饮服务;冷饮店;冷饮店</td>\n",
       "      <td>[]</td>\n",
       "      <td>西北</td>\n",
       "      <td>74.1376</td>\n",
       "      <td>113.677941,23.629029</td>\n",
       "      <td>博学路广州南方学院综合楼内</td>\n",
       "      <td>0.17934</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B0HGDU76L2</td>\n",
       "      <td>广州南方学院2号实验楼</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>280.003</td>\n",
       "      <td>113.678211,23.630956</td>\n",
       "      <td>博学路</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B0FFKP838K</td>\n",
       "      <td>教学楼3号(外国语学院)</td>\n",
       "      <td>科教文化服务;学校;高等院校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>298.093</td>\n",
       "      <td>113.677247,23.630947</td>\n",
       "      <td>博学路25</td>\n",
       "      <td>0.191742</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B0FFKSF1FI</td>\n",
       "      <td>香辣螺蛳粉</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>17820061022</td>\n",
       "      <td>西</td>\n",
       "      <td>209.206</td>\n",
       "      <td>113.676231,23.628565</td>\n",
       "      <td>广州南方学院西4123</td>\n",
       "      <td>0.209252</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B0HGDU8NLD</td>\n",
       "      <td>广州南方学院1号实验楼</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>326.007</td>\n",
       "      <td>113.678215,23.631370</td>\n",
       "      <td>博学路附近</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B0FFLF90I2</td>\n",
       "      <td>煌上煌酱鸭(南方学院店)</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>13712317721</td>\n",
       "      <td>东北</td>\n",
       "      <td>256.772</td>\n",
       "      <td>113.679965,23.630156</td>\n",
       "      <td>笃行路20、22、24号广州南方学院商业中心1层1F015</td>\n",
       "      <td>0.209448</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B0HGD58UTU</td>\n",
       "      <td>广州南方学院2号教学楼</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>西北</td>\n",
       "      <td>346.352</td>\n",
       "      <td>113.677060,23.631346</td>\n",
       "      <td>博学路</td>\n",
       "      <td>0.191229</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B0H25SMRKP</td>\n",
       "      <td>广州南方学院大礼堂</td>\n",
       "      <td>科教文化服务;会展中心;会展中心</td>\n",
       "      <td>[]</td>\n",
       "      <td>东北</td>\n",
       "      <td>386.65</td>\n",
       "      <td>113.680076,23.631502</td>\n",
       "      <td>温泉大道882号</td>\n",
       "      <td>0.261624</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B0HGDU92JD</td>\n",
       "      <td>广州南方学院教学楼1号</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>391.548</td>\n",
       "      <td>113.677077,23.631783</td>\n",
       "      <td>博学路19号</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B0HGD592BJ</td>\n",
       "      <td>广州南方学院综合楼</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>东北</td>\n",
       "      <td>392.731</td>\n",
       "      <td>113.680117,23.631544</td>\n",
       "      <td>温泉大道886号广州南方学院内</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B0FFKP81F0</td>\n",
       "      <td>教学楼1号(文学与传媒学院)</td>\n",
       "      <td>科教文化服务;科教文化场所;科教文化场所</td>\n",
       "      <td>[]</td>\n",
       "      <td>西北</td>\n",
       "      <td>393.93</td>\n",
       "      <td>113.676866,23.631736</td>\n",
       "      <td>博学路19号附近</td>\n",
       "      <td>0.191742</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B0FFLBEOND</td>\n",
       "      <td>聚贤楼10号</td>\n",
       "      <td>商务住宅;住宅区;宿舍</td>\n",
       "      <td>[]</td>\n",
       "      <td>东北</td>\n",
       "      <td>418.51</td>\n",
       "      <td>113.681253,23.631036</td>\n",
       "      <td>从莞深高速(广州南方学院)</td>\n",
       "      <td>0.190963</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B0FFH6K3U9</td>\n",
       "      <td>广州中大南方招待所</td>\n",
       "      <td>住宿服务;住宿服务相关;住宿服务相关</td>\n",
       "      <td>020-61787222</td>\n",
       "      <td>西北</td>\n",
       "      <td>378.102</td>\n",
       "      <td>113.676330,23.631332</td>\n",
       "      <td>温泉镇温泉大道882号广州南方学院H7栋1-5层</td>\n",
       "      <td>0.254885</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B0HGD58NF8</td>\n",
       "      <td>广州南方学院达人书院</td>\n",
       "      <td>科教文化服务;科教文化场所;科教文化场所</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>446.366</td>\n",
       "      <td>113.679041,23.632392</td>\n",
       "      <td>温泉大道882号广州南方学院新综合楼2层</td>\n",
       "      <td>0.191229</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B0FFKUVYWV</td>\n",
       "      <td>广州和风庭阿七度假别墅</td>\n",
       "      <td>住宿服务;住宿服务相关;住宿服务相关</td>\n",
       "      <td>[]</td>\n",
       "      <td>东北</td>\n",
       "      <td>424.35</td>\n",
       "      <td>113.681736,23.630569</td>\n",
       "      <td>保利桃花源</td>\n",
       "      <td>0.273168</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B0HGDU99RM</td>\n",
       "      <td>广州南方学院图书馆</td>\n",
       "      <td>科教文化服务;图书馆;图书馆</td>\n",
       "      <td>020-61787368;020-61787371</td>\n",
       "      <td>北</td>\n",
       "      <td>489.331</td>\n",
       "      <td>113.679177,23.632762</td>\n",
       "      <td>温泉大道882号广州南方学院内</td>\n",
       "      <td>0.257947</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B0HGDU92JC</td>\n",
       "      <td>广州南方学院4号实验楼</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>498.883</td>\n",
       "      <td>113.679963,23.632652</td>\n",
       "      <td>博学路附近</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B0FFL7C054</td>\n",
       "      <td>广州U优森特酒店</td>\n",
       "      <td>住宿服务;住宿服务相关;住宿服务相关</td>\n",
       "      <td>15813395296</td>\n",
       "      <td>北</td>\n",
       "      <td>464.819</td>\n",
       "      <td>113.679226,23.632528</td>\n",
       "      <td>温泉镇博学路882号(广州南方学院商业中心1层)</td>\n",
       "      <td>0.317505</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B0FFG8CSEK</td>\n",
       "      <td>L5员工宿舍</td>\n",
       "      <td>商务住宅;住宅区;宿舍</td>\n",
       "      <td>[]</td>\n",
       "      <td>东北</td>\n",
       "      <td>554.129</td>\n",
       "      <td>113.682583,23.631487</td>\n",
       "      <td>从莞深高速(广州南方学院)</td>\n",
       "      <td>0.185371</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>B0HGD58FR2</td>\n",
       "      <td>广州南方学院教学楼9号</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>532.163</td>\n",
       "      <td>113.679747,23.633032</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B0HG5Z9JNK</td>\n",
       "      <td>广州南方学院教学楼7号</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>544.868</td>\n",
       "      <td>113.678600,23.633330</td>\n",
       "      <td>博学路</td>\n",
       "      <td>0.221553</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>B0HGD599JM</td>\n",
       "      <td>广州南方学院第11教学楼</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>556.036</td>\n",
       "      <td>113.680037,23.633173</td>\n",
       "      <td>温泉大道882号广州南方学院</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>B0GUJYPEG2</td>\n",
       "      <td>怒烤烤串(从化店)</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>510.112</td>\n",
       "      <td>113.677160,23.632910</td>\n",
       "      <td>温泉大道882号广州南方学院内博学路6号之3</td>\n",
       "      <td>0.216026</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>B0HGDU6Z41</td>\n",
       "      <td>广州南方学院教学楼6号</td>\n",
       "      <td>科教文化服务;学校;学校</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>586.331</td>\n",
       "      <td>113.678424,23.633710</td>\n",
       "      <td>温泉大道882</td>\n",
       "      <td>0.221662</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id            name                  type  \\\n",
       "0   B00140MR9A          广州南方学院        科教文化服务;学校;高等院校   \n",
       "1   B0FFG4TAF2          广州南方公寓    商务住宅;商务住宅相关;商务住宅相关   \n",
       "2   B0H6FA18J5          保利半山花园          商务住宅;住宅区;住宅区   \n",
       "3   B00140TWHT          教工住宅1号         商务住宅;住宅区;住宅小区   \n",
       "4   B0FFHRJDM9            中南公寓         商务住宅;住宅区;住宅小区   \n",
       "5   B0HGD588HJ     广州南方学院教学楼4号          科教文化服务;学校;学校   \n",
       "6   B0FFHZH0IK             地下铁          餐饮服务;冷饮店;冷饮店   \n",
       "7   B0HGDU76L2     广州南方学院2号实验楼          科教文化服务;学校;学校   \n",
       "8   B0FFKP838K    教学楼3号(外国语学院)        科教文化服务;学校;高等院校   \n",
       "9   B0FFKSF1FI           香辣螺蛳粉      餐饮服务;餐饮相关场所;餐饮相关   \n",
       "10  B0HGDU8NLD     广州南方学院1号实验楼          科教文化服务;学校;学校   \n",
       "11  B0FFLF90I2    煌上煌酱鸭(南方学院店)          餐饮服务;快餐厅;快餐厅   \n",
       "12  B0HGD58UTU     广州南方学院2号教学楼          科教文化服务;学校;学校   \n",
       "13  B0H25SMRKP       广州南方学院大礼堂      科教文化服务;会展中心;会展中心   \n",
       "14  B0HGDU92JD     广州南方学院教学楼1号          科教文化服务;学校;学校   \n",
       "15  B0HGD592BJ       广州南方学院综合楼          科教文化服务;学校;学校   \n",
       "16  B0FFKP81F0  教学楼1号(文学与传媒学院)  科教文化服务;科教文化场所;科教文化场所   \n",
       "17  B0FFLBEOND          聚贤楼10号           商务住宅;住宅区;宿舍   \n",
       "18  B0FFH6K3U9       广州中大南方招待所    住宿服务;住宿服务相关;住宿服务相关   \n",
       "19  B0HGD58NF8      广州南方学院达人书院  科教文化服务;科教文化场所;科教文化场所   \n",
       "20  B0FFKUVYWV     广州和风庭阿七度假别墅    住宿服务;住宿服务相关;住宿服务相关   \n",
       "21  B0HGDU99RM       广州南方学院图书馆        科教文化服务;图书馆;图书馆   \n",
       "22  B0HGDU92JC     广州南方学院4号实验楼          科教文化服务;学校;学校   \n",
       "23  B0FFL7C054        广州U优森特酒店    住宿服务;住宿服务相关;住宿服务相关   \n",
       "24  B0FFG8CSEK          L5员工宿舍           商务住宅;住宅区;宿舍   \n",
       "25  B0HGD58FR2     广州南方学院教学楼9号          科教文化服务;学校;学校   \n",
       "26  B0HG5Z9JNK     广州南方学院教学楼7号          科教文化服务;学校;学校   \n",
       "27  B0HGD599JM    广州南方学院第11教学楼          科教文化服务;学校;学校   \n",
       "28  B0GUJYPEG2       怒烤烤串(从化店)    餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "29  B0HGDU6Z41     广州南方学院教学楼6号          科教文化服务;学校;学校   \n",
       "\n",
       "                          tel direction distance              location  \\\n",
       "0   020-87828988;020-61787331         北  470.792  113.679257,23.632577   \n",
       "1                 13622768437        东南  102.617  113.678983,23.627778   \n",
       "2                          []        东南  139.054  113.679358,23.627672   \n",
       "3                          []         北  222.658  113.678490,23.630432   \n",
       "4                 13711245345        东南  231.223  113.680340,23.627566   \n",
       "5                          []         北  242.901  113.677460,23.630490   \n",
       "6                          []        西北  74.1376  113.677941,23.629029   \n",
       "7                          []         北  280.003  113.678211,23.630956   \n",
       "8                          []         北  298.093  113.677247,23.630947   \n",
       "9                 17820061022         西  209.206  113.676231,23.628565   \n",
       "10                         []         北  326.007  113.678215,23.631370   \n",
       "11                13712317721        东北  256.772  113.679965,23.630156   \n",
       "12                         []        西北  346.352  113.677060,23.631346   \n",
       "13                         []        东北   386.65  113.680076,23.631502   \n",
       "14                         []         北  391.548  113.677077,23.631783   \n",
       "15                         []        东北  392.731  113.680117,23.631544   \n",
       "16                         []        西北   393.93  113.676866,23.631736   \n",
       "17                         []        东北   418.51  113.681253,23.631036   \n",
       "18               020-61787222        西北  378.102  113.676330,23.631332   \n",
       "19                         []         北  446.366  113.679041,23.632392   \n",
       "20                         []        东北   424.35  113.681736,23.630569   \n",
       "21  020-61787368;020-61787371         北  489.331  113.679177,23.632762   \n",
       "22                         []         北  498.883  113.679963,23.632652   \n",
       "23                15813395296         北  464.819  113.679226,23.632528   \n",
       "24                         []        东北  554.129  113.682583,23.631487   \n",
       "25                         []         北  532.163  113.679747,23.633032   \n",
       "26                         []         北  544.868  113.678600,23.633330   \n",
       "27                         []         北  556.036  113.680037,23.633173   \n",
       "28                         []         北  510.112  113.677160,23.632910   \n",
       "29                         []         北  586.331  113.678424,23.633710   \n",
       "\n",
       "                          address poiweight businessarea  \n",
       "0                        温泉大道882号  0.450402           []  \n",
       "1               温泉镇乌土村松浪队5号(近博学路)  0.237309           []  \n",
       "2                 从莞深高速(广州南方学院南侧)  0.223065           []  \n",
       "3                            笃行路2  0.157653           []  \n",
       "4                      中大南方学院南门1号  0.256152           []  \n",
       "5                             博学路  0.221662           []  \n",
       "6                   博学路广州南方学院综合楼内   0.17934           []  \n",
       "7                             博学路  0.221662           []  \n",
       "8                           博学路25  0.191742           []  \n",
       "9                     广州南方学院西4123  0.209252           []  \n",
       "10                          博学路附近  0.221662           []  \n",
       "11  笃行路20、22、24号广州南方学院商业中心1层1F015  0.209448           []  \n",
       "12                            博学路  0.191229           []  \n",
       "13                       温泉大道882号  0.261624           []  \n",
       "14                         博学路19号  0.221662           []  \n",
       "15                温泉大道886号广州南方学院内  0.221662           []  \n",
       "16                       博学路19号附近  0.191742           []  \n",
       "17                  从莞深高速(广州南方学院)  0.190963           []  \n",
       "18       温泉镇温泉大道882号广州南方学院H7栋1-5层  0.254885           []  \n",
       "19           温泉大道882号广州南方学院新综合楼2层  0.191229           []  \n",
       "20                          保利桃花源  0.273168           []  \n",
       "21                温泉大道882号广州南方学院内  0.257947           []  \n",
       "22                          博学路附近  0.221662           []  \n",
       "23       温泉镇博学路882号(广州南方学院商业中心1层)  0.317505           []  \n",
       "24                  从莞深高速(广州南方学院)  0.185371           []  \n",
       "25                         广州南方学院  0.221662           []  \n",
       "26                            博学路  0.221553           []  \n",
       "27                 温泉大道882号广州南方学院  0.221662           []  \n",
       "28         温泉大道882号广州南方学院内博学路6号之3  0.216026           []  \n",
       "29                        温泉大道882  0.221662           []  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['regeocode']['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "92a615c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "def food_poi(location):\n",
    "    url=\"https://restapi.amap.com/v3/place/around?parameters\"\n",
    "    params={\n",
    "        \"key\":\"17ceaab8de5fd9472eb40a8cfdbdce5e\",\n",
    "        \"location\":location,\n",
    "        \"types\":\"050000\",\n",
    "        \"city\":\"广州\",\n",
    "        \"extensions\":\"all\",\n",
    "        \"offset\":25\n",
    "    }\n",
    "    r=requests.get(url,params=params)\n",
    "    return r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "e83578e3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'parent': 'B00140TFHO',\n",
       "  'distance': '20',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.1', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;咖啡厅;咖啡厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050500',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0I6MZXWSE',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '113.328229,23.133192',\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-21 20:57:09',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳金殿37层3709',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '御咲漫研咖啡',\n",
       "  'location': '113.327955,23.132367',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '24',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '100.00', 'rating': '4.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/4845608efe18b2ed5597f56925a80f05'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/028a64a4cd00ec0458c6001ae5892322'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/04cebc6a162cf77a154c8d89529cc8ac'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-83333279',\n",
       "  'id': 'B0HAL16X3R',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 07:18:46',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场3楼烧江南烤肉3A020铺',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210301171',\n",
       "   'truefloor': 'F3',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '3'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '烧江南(正佳广场店)',\n",
       "  'location': '113.327770,23.132274',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '25',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '82.00', 'rating': '4.7', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/852ec0511b80761a0d6300bbba47b511'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0a952b542c6de55f1aeab5b13dac878c'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/11466bf6f9f104442e41482e3d2b7a53'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050118',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-88521947',\n",
       "  'id': 'B0HAL16X3T',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-20 13:36:29',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场五楼广正街',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210501259',\n",
       "   'truefloor': 'F5',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '5'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '大吉大莉餐廳·南洋中餐(正佳广场店)',\n",
       "  'location': '113.327745,23.132230',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '26',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.5', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/224e9a6b0df2ba85c46ef2fc3b612daa'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/e1d953572d62a6c49849f00b5db8d702'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/e3e27ede48a72a36616d20590e06dc66'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-85510960',\n",
       "  'id': 'B0I6B1SLSC',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-17 23:00:14',\n",
       "  'website': [],\n",
       "  'address': '正佳广场5楼广正街(体育中心地铁站出入口旁)',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '大榕树下(正佳广场店)',\n",
       "  'location': '113.327751,23.132089',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '27',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.1', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;外国餐厅;日本料理',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/b3df2c099aa18d0b4ed0b2255bf9a933'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050202',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-87711442',\n",
       "  'id': 'B0H0AMSEQ2',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-21 00:08:59',\n",
       "  'website': [],\n",
       "  'address': '天河路228号之一',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '丸创寿喜烧（正佳店）',\n",
       "  'location': '113.327731,23.132118',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '29',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '88.00', 'rating': '4.7', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;云贵菜',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/b1fa1dcf1096c6b923f0b8896a046840'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/005a38e643bc407ab4442193a86a5fe4'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/014a842fc3477086ec497ec7a4aa2a3b'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050114',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-38331558;020-38331337;4009912727',\n",
       "  'id': 'B0H2PRRF7Y',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 04:36:34',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场F6层6C053-55',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '云海肴云南菜(正佳广场店)',\n",
       "  'location': '113.327707,23.132154',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFG50WV6',\n",
       "  'distance': '33',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;咖啡厅;咖啡厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050500',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0IG2Z4UJ7',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-19 03:42:08',\n",
       "  'website': [],\n",
       "  'address': '体育东路与创汇街交叉口西80米',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': 'roina木春(正佳广场店)',\n",
       "  'location': '113.327673,23.132260',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFG50WV6',\n",
       "  'distance': '33',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '23.00', 'rating': '4.3', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;冷饮店;冷饮店',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/c9673a7724c39ca78c5a74a3196b1fd9'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0dab09a86ed8a529cda4375a677291bf'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/15642a2a04fbb050e3f8e7960e1427c4'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050700',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18001309703',\n",
       "  'id': 'B0H3SSIZED',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 05:28:10',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场F1',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': 'PINTEA(正佳广场一店)',\n",
       "  'location': '113.327727,23.132005',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '34',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '85.00', 'rating': '4.5', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/fe620f4b93ba483dcd4b12964cf5148e'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/2f4b6e51e12d3d427e004610f3754b93'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/b6b32d4c4160b7cff7b6b24e3a6afc04'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050000',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-87579057',\n",
       "  'id': 'B0HG0SYIEF',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 06:55:21',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场F4层4A031',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210401151',\n",
       "   'truefloor': 'F4',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '4'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '蔡澜港式点心(正佳广场店)',\n",
       "  'location': '113.327770,23.131955',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '34',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '78.00', 'rating': '4.7', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/f1bb45848e4bc5c2b98fffed324dcc6b'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0cfeb31f1d2f3ac460a56a498c403d82'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/1288cc23dfba4090103347cd8e9bd7b9'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050118',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '4006092822',\n",
       "  'id': 'B0HG0SYIDQ',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '113.328094,23.130963',\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 08:06:58',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场东南区3楼',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210301144',\n",
       "   'truefloor': 'F3',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '3'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '太二酸菜鱼(广州正佳广场店)',\n",
       "  'location': '113.327716,23.132002',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '39',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '130.00', 'rating': '4.7', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;火锅店',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/23ec00bd78c2b009ef48efc4b1f56100'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/07cb02c736b938e095dce8986cceb8ad'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0a3a2abadebfecac9884ea933676a74d'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050117',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-87066433',\n",
       "  'id': 'B0FFI7WHLB',\n",
       "  'tag': '极品鲜鹅肠,红糖糍粑,现炸酥肉',\n",
       "  'event': [],\n",
       "  'entr_location': '113.32811,23.130964',\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 06:32:50',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场三楼东街3A020-5、7铺(近友谊广场)',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210301145',\n",
       "   'truefloor': 'F3',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '3'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '小龙坎老火锅(正佳店)',\n",
       "  'location': '113.327826,23.131864',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '42',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.7', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/57d48791d7e9cf61032a23a48fecd4b1'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/2ed1a9894a4d7e08a407a7f3e4c04c04'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/3397653b95f9959e7c816b2df1278449'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050000',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18938384110',\n",
       "  'id': 'B0HKUSUW72',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '113.327995,23.130963',\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 07:49:46',\n",
       "  'website': [],\n",
       "  'address': '正佳广场5A023-024铺(体育中心地铁站出入口旁)',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '猫抓烤肉(正佳广场店)',\n",
       "  'location': '113.327707,23.132472',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '44',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050000',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0H0OYWWK8',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-18 05:42:44',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场F1-1G001',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '伏見桃山(正佳广场店)',\n",
       "  'location': '113.327556,23.132143',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '47',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '40.00', 'rating': '4.4', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;火锅店',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/819ffbe8beab85b355a76991b9b582f9'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/56fcc787a3105a2790eccee1'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/5607cc10a310c5a615aa6ac1'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050117',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18027335485',\n",
       "  'id': 'B0FFFP1NL4',\n",
       "  'tag': '金针菇,黑毛肚,脆皮肠,味行动麻辣香锅,冬菇,土豆,土豆片,培根,墨鱼腰花,娃娃菜,平菇,木耳,椰汁,海带,海鲜菇',\n",
       "  'event': [],\n",
       "  'entr_location': '113.328226,23.133235',\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 06:40:52',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场M层E126号商铺',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950200100002',\n",
       "   'truefloor': 'M',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '-1'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '味行动麻辣香锅(正佳广场店)',\n",
       "  'location': '113.327553,23.132327',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '49',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '23.00', 'rating': '4.3', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;冷饮店;冷饮店',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/2b6232347b64874d733e7e1cc9b918b7'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/180c79f859a8f1fc6d26b0f2a101cf2a'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/223fd007a95918196eb46033372c9310'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050700',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '13751796173;19924775527',\n",
       "  'id': 'B0G3LYFVKR',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 01:34:05',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场负一楼B1-019(翠华右手边)',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210101161',\n",
       "   'truefloor': 'F1',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '1'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '伏小桃(正佳广场店)',\n",
       "  'location': '113.327511,23.132106',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '50',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '74.00', 'rating': '4.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/fc861893c44dc2eb8e724793f1ee961c'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/3f34e183164d7c279a9bd024259f1e16'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/a7506baeaab4dfbfc7e1507249492942'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0G1AX0Z7M',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '113.32823,23.133175',\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 03:16:05',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场401铺',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210401150',\n",
       "   'truefloor': 'F4',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '4'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '俏九州·小炒黄牛肉(广州正佳广场店)',\n",
       "  'location': '113.327698,23.131826',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '53',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;冷饮店;冷饮店',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0bcad1e641d451705e6f4d15610d203f'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/5444658c4b3d39fc474841837e842c18'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/d1ad6bd9115a6a259484a886e6b2d3f2'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050700',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18588868243',\n",
       "  'id': 'B0H3SAL2BW',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-17 23:35:46',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场2f东街ur旁边',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': 'roma木春(正佳广场店)',\n",
       "  'location': '113.327516,23.132382',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '56',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/93ab4e3985f75ad97c2279d7701f6de3'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0G3JK3946',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-18 06:47:46',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场M层E46号铺',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950200100001',\n",
       "   'truefloor': 'M',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '-1'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '鲍叔捞饭(正佳广场店)',\n",
       "  'location': '113.327577,23.132528',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '62',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '110.00', 'rating': '4.7', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/7b533e7aa3a3fcac6bdbcd202063116a'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/2aabcbafb3fe68b0d34a98589b7c771b'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/39732c1fa160d8c15c41fe5edb7bfb18'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050118',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-38856267;020-83627041',\n",
       "  'id': 'B0G0L1LGUA',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 05:43:04',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场东北中庭4F-4AO23-27号',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210401154',\n",
       "   'truefloor': 'F4',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '4'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '钢管厂五区小郡肝串串香(正佳广场店)',\n",
       "  'location': '113.327617,23.132631',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '65',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '139.00', 'rating': '4.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;火锅店|餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/2741b567ce7a52ec2e23adbf0ebfb53a'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/028fe0f493c83565721dbe2ed8c39d80'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0ac61c7cdb88a211d03ab5041af7b1f2'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050117|050118',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-89815851',\n",
       "  'id': 'B0G33MUM57',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '113.32824,23.133025',\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 01:37:08',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场4F-4A033商铺',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210401149',\n",
       "   'truefloor': 'F4',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '4'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '哥老官(正佳广场店)',\n",
       "  'location': '113.327649,23.131687',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '66',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050000',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0H1S7JVE0',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '113.328329,23.13326',\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 05:56:39',\n",
       "  'website': [],\n",
       "  'address': '正佳广场5层(体育中心地铁站出入口旁)',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '逸只·新加坡海南陵乡鸡',\n",
       "  'location': '113.327352,23.132095',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '67',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '43.00', 'rating': '4.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;快餐厅;茶餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/2921db7f26973e742c760882268b3ece'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/b1886468782a10f021c9ad23d9d8c7da'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/2e6ee6c11bf0f34a2105475c278103e2'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050305',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-38060020',\n",
       "  'id': 'B0FFFFTIEF',\n",
       "  'tag': '一口西多士,手摇弹珠奶茶,蛋挞,番茄牛肉面,黑松露炒蛋,招牌炸豆腐,常餐,冰棍奶茶,招牌芝士丸芝士捞丁,蒜香鸡翅,恐龙阿华田,通心粉,传统菠萝油,黑椒鸡扒牛角包,黑松露炒蛋公仔麵',\n",
       "  'event': [],\n",
       "  'entr_location': '113.3283,23.133251',\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 05:20:11',\n",
       "  'website': [],\n",
       "  'address': '正佳广场N1107-N1111',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950200100004',\n",
       "   'truefloor': 'M',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '-1'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '九龙冰室(正佳广场店)',\n",
       "  'location': '113.327352,23.132328',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '75',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.1', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/9f022e6e6f43ef24fd67c5c926492063'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/1266d8c86968f1277349126a38da3786'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/3cfef7039faecc6c0de764bf553579e8'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0HKV74XBN',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '113.328078,23.130961',\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-25 23:23:30',\n",
       "  'website': [],\n",
       "  'address': '天河路288号正佳广场5层(体育中心地铁站出入口旁)',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '和府小面小酒(正佳广场店)',\n",
       "  'location': '113.327427,23.131756',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B00140TFHO',\n",
       "  'distance': '76',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '25.00', 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;冷饮店;冷饮店',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/96ec1e9fa93531a0753994b7f32a227b'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/56fcc78ba3105a2790eccfbc'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/21b16a2f982cd032b9f6d2c5f4951b60'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050700',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '020-38331867',\n",
       "  'id': 'B00140SHUG',\n",
       "  'tag': '榴莲味,蓝莓,提拉米苏,芝士,柠檬,咖啡,黑朱古力味,雪梨汁,栗子味,绿茶雪糕,华夫杯,板栗,香芋,水果雪糕,香芋雪糕',\n",
       "  'event': [],\n",
       "  'entr_location': '113.328095,23.130963',\n",
       "  'indoor_map': '1',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 07:15:09',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳广场一楼东北门1G011铺',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': '510620',\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': '37950210101093',\n",
       "   'truefloor': 'F1',\n",
       "   'cpid': 'B00140TFHO',\n",
       "   'floor': '1'},\n",
       "  'childtype': '201',\n",
       "  'exit_location': [],\n",
       "  'name': '芭克·闪冰意大利冰淇淋·咖啡(正佳广场店)',\n",
       "  'location': '113.327425,23.132633',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F011043_50816',\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFG50WV6',\n",
       "  'distance': '77',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '2.2', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3413525620',\n",
       "  'typecode': '050000',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '020',\n",
       "  'adname': '天河区',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0HKLRVFKL',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-18 03:37:02',\n",
       "  'website': [],\n",
       "  'address': '天河路228号正佳购物广场5楼(近体育中心)正佳百货F3',\n",
       "  'adcode': '440106',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '广州市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': [],\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '奶茶车间(正佳百货店)',\n",
       "  'location': '113.327631,23.132802',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'}]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "location=\"113.327990,23.132189\"\n",
    "food_poi(location)[\"pois\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "40697d53",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "0c2abf93",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区温泉镇博学路广州南方学院',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '温泉镇',\n",
       "   'towncode': '440117100000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '博学路',\n",
       "    'number': '24号',\n",
       "    'location': '113.677267,23.629149',\n",
       "    'direction': '西北',\n",
       "    'distance': '129.943'},\n",
       "   'businessAreas': [[]]},\n",
       "  'pois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': '020-87828988;020-61787331',\n",
       "    'direction': '北',\n",
       "    'distance': '470.792',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.450402',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG4TAF2',\n",
       "    'name': '广州南方公寓',\n",
       "    'type': '商务住宅;商务住宅相关;商务住宅相关',\n",
       "    'tel': '13622768437',\n",
       "    'direction': '东南',\n",
       "    'distance': '102.617',\n",
       "    'location': '113.678983,23.627778',\n",
       "    'address': '温泉镇乌土村松浪队5号(近博学路)',\n",
       "    'poiweight': '0.237309',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H6FA18J5',\n",
       "    'name': '保利半山花园',\n",
       "    'type': '商务住宅;住宅区;住宅区',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '139.054',\n",
       "    'location': '113.679358,23.627672',\n",
       "    'address': '从莞深高速(广州南方学院南侧)',\n",
       "    'poiweight': '0.223065',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B00140TWHT',\n",
       "    'name': '教工住宅1号',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '222.658',\n",
       "    'location': '113.678490,23.630432',\n",
       "    'address': '笃行路2',\n",
       "    'poiweight': '0.157653',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHRJDM9',\n",
       "    'name': '中南公寓',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': '13711245345',\n",
       "    'direction': '东南',\n",
       "    'distance': '231.223',\n",
       "    'location': '113.680340,23.627566',\n",
       "    'address': '中大南方学院南门1号',\n",
       "    'poiweight': '0.256152',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD588HJ',\n",
       "    'name': '广州南方学院教学楼4号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '242.901',\n",
       "    'location': '113.677460,23.630490',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHZH0IK',\n",
       "    'name': '地下铁',\n",
       "    'type': '餐饮服务;冷饮店;冷饮店',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '74.1376',\n",
       "    'location': '113.677941,23.629029',\n",
       "    'address': '博学路广州南方学院综合楼内',\n",
       "    'poiweight': '0.17934',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU76L2',\n",
       "    'name': '广州南方学院2号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '280.003',\n",
       "    'location': '113.678211,23.630956',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP838K',\n",
       "    'name': '教学楼3号(外国语学院)',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '298.093',\n",
       "    'location': '113.677247,23.630947',\n",
       "    'address': '博学路25',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKSF1FI',\n",
       "    'name': '香辣螺蛳粉',\n",
       "    'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "    'tel': '17820061022',\n",
       "    'direction': '西',\n",
       "    'distance': '209.206',\n",
       "    'location': '113.676231,23.628565',\n",
       "    'address': '广州南方学院西4123',\n",
       "    'poiweight': '0.209252',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU8NLD',\n",
       "    'name': '广州南方学院1号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '326.007',\n",
       "    'location': '113.678215,23.631370',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLF90I2',\n",
       "    'name': '煌上煌酱鸭(南方学院店)',\n",
       "    'type': '餐饮服务;快餐厅;快餐厅',\n",
       "    'tel': '13712317721',\n",
       "    'direction': '东北',\n",
       "    'distance': '256.772',\n",
       "    'location': '113.679965,23.630156',\n",
       "    'address': '笃行路20、22、24号广州南方学院商业中心1层1F015',\n",
       "    'poiweight': '0.209448',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58UTU',\n",
       "    'name': '广州南方学院2号教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '346.352',\n",
       "    'location': '113.677060,23.631346',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H25SMRKP',\n",
       "    'name': '广州南方学院大礼堂',\n",
       "    'type': '科教文化服务;会展中心;会展中心',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '386.65',\n",
       "    'location': '113.680076,23.631502',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.261624',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JD',\n",
       "    'name': '广州南方学院教学楼1号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '391.548',\n",
       "    'location': '113.677077,23.631783',\n",
       "    'address': '博学路19号',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD592BJ',\n",
       "    'name': '广州南方学院综合楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '392.731',\n",
       "    'location': '113.680117,23.631544',\n",
       "    'address': '温泉大道886号广州南方学院内',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP81F0',\n",
       "    'name': '教学楼1号(文学与传媒学院)',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '393.93',\n",
       "    'location': '113.676866,23.631736',\n",
       "    'address': '博学路19号附近',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLBEOND',\n",
       "    'name': '聚贤楼10号',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '418.51',\n",
       "    'location': '113.681253,23.631036',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.190963',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFH6K3U9',\n",
       "    'name': '广州中大南方招待所',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '020-61787222',\n",
       "    'direction': '西北',\n",
       "    'distance': '378.102',\n",
       "    'location': '113.676330,23.631332',\n",
       "    'address': '温泉镇温泉大道882号广州南方学院H7栋1-5层',\n",
       "    'poiweight': '0.254885',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58NF8',\n",
       "    'name': '广州南方学院达人书院',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '446.366',\n",
       "    'location': '113.679041,23.632392',\n",
       "    'address': '温泉大道882号广州南方学院新综合楼2层',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKUVYWV',\n",
       "    'name': '广州和风庭阿七度假别墅',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '424.35',\n",
       "    'location': '113.681736,23.630569',\n",
       "    'address': '保利桃花源',\n",
       "    'poiweight': '0.273168',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU99RM',\n",
       "    'name': '广州南方学院图书馆',\n",
       "    'type': '科教文化服务;图书馆;图书馆',\n",
       "    'tel': '020-61787368;020-61787371',\n",
       "    'direction': '北',\n",
       "    'distance': '489.331',\n",
       "    'location': '113.679177,23.632762',\n",
       "    'address': '温泉大道882号广州南方学院内',\n",
       "    'poiweight': '0.257947',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JC',\n",
       "    'name': '广州南方学院4号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '498.883',\n",
       "    'location': '113.679963,23.632652',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFL7C054',\n",
       "    'name': '广州U优森特酒店',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '15813395296',\n",
       "    'direction': '北',\n",
       "    'distance': '464.819',\n",
       "    'location': '113.679226,23.632528',\n",
       "    'address': '温泉镇博学路882号(广州南方学院商业中心1层)',\n",
       "    'poiweight': '0.317505',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG8CSEK',\n",
       "    'name': 'L5员工宿舍',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '554.129',\n",
       "    'location': '113.682583,23.631487',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.185371',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58FR2',\n",
       "    'name': '广州南方学院教学楼9号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '532.163',\n",
       "    'location': '113.679747,23.633032',\n",
       "    'address': '广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HG5Z9JNK',\n",
       "    'name': '广州南方学院教学楼7号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '544.868',\n",
       "    'location': '113.678600,23.633330',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221553',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD599JM',\n",
       "    'name': '广州南方学院第11教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '556.036',\n",
       "    'location': '113.680037,23.633173',\n",
       "    'address': '温泉大道882号广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0GUJYPEG2',\n",
       "    'name': '怒烤烤串(从化店)',\n",
       "    'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '510.112',\n",
       "    'location': '113.677160,23.632910',\n",
       "    'address': '温泉大道882号广州南方学院内博学路6号之3',\n",
       "    'poiweight': '0.216026',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU6Z41',\n",
       "    'name': '广州南方学院教学楼6号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '586.331',\n",
       "    'location': '113.678424,23.633710',\n",
       "    'address': '温泉大道882',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []}],\n",
       "  'roads': [{'id': '020F49F0050461206',\n",
       "    'name': '博学路',\n",
       "    'direction': '北',\n",
       "    'distance': '7.63232',\n",
       "    'location': '113.678,23.6284'},\n",
       "   {'id': '020F49F0050462229',\n",
       "    'name': '老虎形街',\n",
       "    'direction': '北',\n",
       "    'distance': '445.159',\n",
       "    'location': '113.679,23.6245'},\n",
       "   {'id': '020F49F0050462451',\n",
       "    'name': '中山路',\n",
       "    'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.677,23.6347'}],\n",
       "  'roadinters': [{'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.676794,23.634661',\n",
       "    'first_id': '020F49F0050461206',\n",
       "    'first_name': '博学路',\n",
       "    'second_id': '020F49F0050462451',\n",
       "    'second_name': '中山路'}],\n",
       "  'aois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'adcode': '440117',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'area': '528560.656426',\n",
       "    'distance': '0',\n",
       "    'type': '141201'}]}}"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "8103b810",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "364d38d9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>distance</th>\n",
       "      <th>pcode</th>\n",
       "      <th>importance</th>\n",
       "      <th>recommend</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>discount_num</th>\n",
       "      <th>gridcode</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>shopid</th>\n",
       "      <th>navi_poiid</th>\n",
       "      <th>groupbuy_num</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "      <th>indoor_data.cmsid</th>\n",
       "      <th>indoor_data.truefloor</th>\n",
       "      <th>indoor_data.cpid</th>\n",
       "      <th>indoor_data.floor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>20</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;咖啡厅;咖啡厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050500</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>24</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210301171</td>\n",
       "      <td>F3</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>25</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>82.00</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210501259</td>\n",
       "      <td>F5</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>26</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>27</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;外国餐厅;日本料理</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050202</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>29</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;云贵菜</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050114</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>88.00</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>B0FFG50WV6</td>\n",
       "      <td>33</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;咖啡厅;咖啡厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050500</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B0FFG50WV6</td>\n",
       "      <td>33</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;冷饮店;冷饮店</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050700</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>23.00</td>\n",
       "      <td>4.3</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>34</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050000</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>85.00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210401151</td>\n",
       "      <td>F4</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>34</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>78.00</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210301144</td>\n",
       "      <td>F3</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>39</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;火锅店</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050117</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>130.00</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210301145</td>\n",
       "      <td>F3</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>42</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050000</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>44</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050000</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>47</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;火锅店</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050117</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>4.4</td>\n",
       "      <td>0</td>\n",
       "      <td>37950200100002</td>\n",
       "      <td>M</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>49</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;冷饮店;冷饮店</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050700</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>23.00</td>\n",
       "      <td>4.3</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210101161</td>\n",
       "      <td>F1</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>50</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>74.00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210401150</td>\n",
       "      <td>F4</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>53</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;冷饮店;冷饮店</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050700</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>56</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>37950200100001</td>\n",
       "      <td>M</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>62</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050118</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>110.00</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210401154</td>\n",
       "      <td>F4</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>65</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;火锅店|餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050117|050118</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>139.00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210401149</td>\n",
       "      <td>F4</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>66</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050000</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>67</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;快餐厅;茶餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050305</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>43.00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0</td>\n",
       "      <td>37950200100004</td>\n",
       "      <td>M</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>75</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>76</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;冷饮店;冷饮店</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050700</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F011043_50816</td>\n",
       "      <td>0</td>\n",
       "      <td>25.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>37950210101093</td>\n",
       "      <td>F1</td>\n",
       "      <td>B00140TFHO</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B0FFG50WV6</td>\n",
       "      <td>77</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;餐饮相关场所;餐饮相关</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3413525620</td>\n",
       "      <td>050000</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.2</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        parent distance   pcode importance recommend  \\\n",
       "0   B00140TFHO       20  440000         []         0   \n",
       "1   B00140TFHO       24  440000         []         0   \n",
       "2   B00140TFHO       25  440000         []         0   \n",
       "3   B00140TFHO       26  440000         []         0   \n",
       "4   B00140TFHO       27  440000         []         0   \n",
       "5   B00140TFHO       29  440000         []         0   \n",
       "6   B0FFG50WV6       33  440000         []         0   \n",
       "7   B0FFG50WV6       33  440000         []         0   \n",
       "8   B00140TFHO       34  440000         []         0   \n",
       "9   B00140TFHO       34  440000         []         0   \n",
       "10  B00140TFHO       39  440000         []         0   \n",
       "11  B00140TFHO       42  440000         []         0   \n",
       "12  B00140TFHO       44  440000         []         0   \n",
       "13  B00140TFHO       47  440000         []         0   \n",
       "14  B00140TFHO       49  440000         []         0   \n",
       "15  B00140TFHO       50  440000         []         0   \n",
       "16  B00140TFHO       53  440000         []         0   \n",
       "17  B00140TFHO       56  440000         []         0   \n",
       "18  B00140TFHO       62  440000         []         0   \n",
       "19  B00140TFHO       65  440000         []         0   \n",
       "20  B00140TFHO       66  440000         []         0   \n",
       "21  B00140TFHO       67  440000         []         0   \n",
       "22  B00140TFHO       75  440000         []         0   \n",
       "23  B00140TFHO       76  440000         []         0   \n",
       "24  B0FFG50WV6       77  440000         []         0   \n",
       "\n",
       "                               type  \\\n",
       "0                      餐饮服务;咖啡厅;咖啡厅   \n",
       "1                      餐饮服务;中餐厅;中餐厅   \n",
       "2                餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "3                      餐饮服务;中餐厅;中餐厅   \n",
       "4                    餐饮服务;外国餐厅;日本料理   \n",
       "5                      餐饮服务;中餐厅;云贵菜   \n",
       "6                      餐饮服务;咖啡厅;咖啡厅   \n",
       "7                      餐饮服务;冷饮店;冷饮店   \n",
       "8                  餐饮服务;餐饮相关场所;餐饮相关   \n",
       "9                餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "10                     餐饮服务;中餐厅;火锅店   \n",
       "11                 餐饮服务;餐饮相关场所;餐饮相关   \n",
       "12                 餐饮服务;餐饮相关场所;餐饮相关   \n",
       "13                     餐饮服务;中餐厅;火锅店   \n",
       "14                     餐饮服务;冷饮店;冷饮店   \n",
       "15                     餐饮服务;中餐厅;中餐厅   \n",
       "16                     餐饮服务;冷饮店;冷饮店   \n",
       "17                     餐饮服务;中餐厅;中餐厅   \n",
       "18               餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "19  餐饮服务;中餐厅;火锅店|餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "20                 餐饮服务;餐饮相关场所;餐饮相关   \n",
       "21                     餐饮服务;快餐厅;茶餐厅   \n",
       "22                     餐饮服务;中餐厅;中餐厅   \n",
       "23                     餐饮服务;冷饮店;冷饮店   \n",
       "24                 餐饮服务;餐饮相关场所;餐饮相关   \n",
       "\n",
       "                                               photos discount_num  \\\n",
       "0                                                  []            0   \n",
       "1   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "2   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "3   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "4   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "5   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "6                                                  []            0   \n",
       "7   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "8   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "9   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "10  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "11  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "12                                                 []            0   \n",
       "13  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "14  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "15  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "16  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "17  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "18  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "19  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "20                                                 []            0   \n",
       "21  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "22  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "23  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "24                                                 []            0   \n",
       "\n",
       "      gridcode       typecode  ... shopid        navi_poiid groupbuy_num  \\\n",
       "0   3413525620         050500  ...     []                []            0   \n",
       "1   3413525620         050100  ...     []                []            0   \n",
       "2   3413525620         050118  ...     []                []            0   \n",
       "3   3413525620         050100  ...     []                []            0   \n",
       "4   3413525620         050202  ...     []                []            0   \n",
       "5   3413525620         050114  ...     []                []            0   \n",
       "6   3413525620         050500  ...     []                []            0   \n",
       "7   3413525620         050700  ...     []                []            0   \n",
       "8   3413525620         050000  ...     []                []            0   \n",
       "9   3413525620         050118  ...     []                []            0   \n",
       "10  3413525620         050117  ...     []                []            0   \n",
       "11  3413525620         050000  ...     []                []            0   \n",
       "12  3413525620         050000  ...     []                []            0   \n",
       "13  3413525620         050117  ...     []                []            0   \n",
       "14  3413525620         050700  ...     []                []            0   \n",
       "15  3413525620         050100  ...     []                []            0   \n",
       "16  3413525620         050700  ...     []                []            0   \n",
       "17  3413525620         050100  ...     []                []            0   \n",
       "18  3413525620         050118  ...     []                []            0   \n",
       "19  3413525620  050117|050118  ...     []                []            0   \n",
       "20  3413525620         050000  ...     []                []            0   \n",
       "21  3413525620         050305  ...     []                []            0   \n",
       "22  3413525620         050100  ...     []                []            0   \n",
       "23  3413525620         050700  ...     []  F49F011043_50816            0   \n",
       "24  3413525620         050000  ...     []                []            0   \n",
       "\n",
       "   biz_ext.cost biz_ext.rating biz_ext.meal_ordering indoor_data.cmsid  \\\n",
       "0            []            4.1                     0                []   \n",
       "1        100.00            4.6                     0    37950210301171   \n",
       "2         82.00            4.7                     0    37950210501259   \n",
       "3            []            4.5                     0                []   \n",
       "4            []            4.1                     0                []   \n",
       "5         88.00            4.7                     0                []   \n",
       "6            []             []                     0                []   \n",
       "7         23.00            4.3                     0                []   \n",
       "8         85.00            4.5                     0    37950210401151   \n",
       "9         78.00            4.7                     0    37950210301144   \n",
       "10       130.00            4.7                     0    37950210301145   \n",
       "11           []            4.7                     0                []   \n",
       "12           []            4.0                     0                []   \n",
       "13        40.00            4.4                     0    37950200100002   \n",
       "14        23.00            4.3                     0    37950210101161   \n",
       "15        74.00            4.6                     0    37950210401150   \n",
       "16           []            4.0                     0                []   \n",
       "17           []             []                     0    37950200100001   \n",
       "18       110.00            4.7                     0    37950210401154   \n",
       "19       139.00            4.6                     0    37950210401149   \n",
       "20           []             []                     0                []   \n",
       "21        43.00            4.6                     0    37950200100004   \n",
       "22           []            4.1                     0                []   \n",
       "23        25.00            4.0                     0    37950210101093   \n",
       "24           []            2.2                     0                []   \n",
       "\n",
       "   indoor_data.truefloor indoor_data.cpid indoor_data.floor  \n",
       "0                     []               []                []  \n",
       "1                     F3       B00140TFHO                 3  \n",
       "2                     F5       B00140TFHO                 5  \n",
       "3                     []               []                []  \n",
       "4                     []               []                []  \n",
       "5                     []               []                []  \n",
       "6                     []               []                []  \n",
       "7                     []               []                []  \n",
       "8                     F4       B00140TFHO                 4  \n",
       "9                     F3       B00140TFHO                 3  \n",
       "10                    F3       B00140TFHO                 3  \n",
       "11                    []               []                []  \n",
       "12                    []               []                []  \n",
       "13                     M       B00140TFHO                -1  \n",
       "14                    F1       B00140TFHO                 1  \n",
       "15                    F4       B00140TFHO                 4  \n",
       "16                    []               []                []  \n",
       "17                     M       B00140TFHO                -1  \n",
       "18                    F4       B00140TFHO                 4  \n",
       "19                    F4       B00140TFHO                 4  \n",
       "20                    []               []                []  \n",
       "21                     M       B00140TFHO                -1  \n",
       "22                    []               []                []  \n",
       "23                    F1       B00140TFHO                 1  \n",
       "24                    []               []                []  \n",
       "\n",
       "[25 rows x 47 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(food_poi(location)[\"pois\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "2165a737",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1. 调用requests模块（google chrome 浏览器）\n",
    "import requests\n",
    "# 2. 请求方法 ： GET\n",
    "# 3. URL地址 ： https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "# 4. 准备参数，用于交换数据 payload\n",
    "payload = {\n",
    "    \"key\":\"17ceaab8de5fd9472eb40a8cfdbdce5e\",\n",
    "    \"address\":\"广东省肇庆市怀集县\"\n",
    "}\n",
    "# 5. 发起请求\n",
    "r = requests.get(url=geo_url, params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "a7ffe7a9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "74bb037f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省肇庆市怀集县',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '0758',\n",
       "   'city': '肇庆市',\n",
       "   'district': '怀集县',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '441224',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '112.184652,23.911899',\n",
       "   'level': '区县'}]}"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "34bff7e6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'112.184652,23.911899'"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "怀集县_location = r.json()['geocodes'][0]['location']\n",
    "怀集县_location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "8d52f6be",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1. 调用requests模块（google chrome 浏览器）\n",
    "import requests\n",
    "# 2. 请求方法 ： GET\n",
    "# 3. URL地址 ： https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "geo_url = \"https://restapi.amap.com/v5/place/text?parameters\"\n",
    "# 4. 准备参数，用于交换数据 payload\n",
    "payload = {\n",
    "    \"key\":\"17ceaab8de5fd9472eb40a8cfdbdce5e\",\n",
    "    \"types\":\"050100\",\n",
    "}\n",
    "# 5. 发起请求\n",
    "r = requests.get(url=geo_url, params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "8818e7b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "7c61dcef",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1', 'info': 'OK', 'infocode': '10000', 'pois': [], 'count': '0'}"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "7bdbb3dc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "def food_poi(location):\n",
    "    url=\"https://restapi.amap.com/v3/place/around?parameters\"\n",
    "    params={\n",
    "        \"key\":\"17ceaab8de5fd9472eb40a8cfdbdce5e\",\n",
    "        \"location\":location,\n",
    "        \"types\":\"050100\",\n",
    "        \"city\":\"肇庆\",\n",
    "        \"extensions\":\"all\",\n",
    "        \"offset\":25\n",
    "    }\n",
    "    r=requests.get(url,params=params)\n",
    "    return r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "4a437f2e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'parent': [],\n",
       "  'distance': '34',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '3.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;四川菜(川菜)',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/61152ca1dbac04c863103b75bbee85c9'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/451e538ac38a82395e07fff52e00ee49'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050102',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0GKPDVPS8',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-03-18 23:15:43',\n",
       "  'website': [],\n",
       "  'address': '怀城街道沿江北路碧桂园玖珑龙湾芷兰湾商业街74号',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '恋上鱼的猫无骨烤鱼捞饭',\n",
       "  'location': '112.184768,23.912187',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '39',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0HROCN6BH',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-17 19:17:57',\n",
       "  'website': [],\n",
       "  'address': '解放北路193城中新街',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '叮当酱·铜锣烧',\n",
       "  'location': '112.184983,23.912086',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '47',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18922621650',\n",
       "  'id': 'B0FFHE0E8E',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-17 17:13:06',\n",
       "  'website': [],\n",
       "  'address': '怀城街道解放中路67号(即城中新街)自编号首层B12单元',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '粉螺香(电视局店)',\n",
       "  'location': '112.184972,23.912206',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '52',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0HKY5Y4R6',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-03-16 00:05:22',\n",
       "  'website': [],\n",
       "  'address': '城中路怀集县教育幼儿园(分园)东南侧约40米',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '永固乡味牛杂',\n",
       "  'location': '112.185168,23.911945',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '54',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/d5aca8ac8ac4e82c8318c090d623da62'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18922635478',\n",
       "  'id': 'B0FFG7ASOM',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-18 12:26:36',\n",
       "  'website': [],\n",
       "  'address': '怀城镇城中路67号',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '食家庄包粥功夫',\n",
       "  'location': '112.185090,23.912183',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F002034_4244',\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFIJYKG2',\n",
       "  'distance': '63',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '16.00', 'rating': '4.3', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/33998510b3b7871f98477fac8c108e45'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/44488a2405b14c028c91685acc852ce7'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/4e4c082f031d36091b7c18e427b740f7'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '17841922191',\n",
       "  'id': 'B0GKRG8IDZ',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 06:12:52',\n",
       "  'website': [],\n",
       "  'address': '解放中路67号自编号首层D3-D5单元商铺',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '不要对我尖叫',\n",
       "  'location': '112.185109,23.911506',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '64',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '13.00', 'rating': '4.3', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;清真菜馆',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/391cadf98b60e545baf3df92c175e376'},\n",
       "   {'title': '木耳炒肉盖浇面',\n",
       "    'url': 'https://img.alicdn.com/imgextra/i2/2206698738327/O1CN01TMesFR2BNocxMQEid_!!2206698738327-0-koubei.jpg'},\n",
       "   {'title': '炸酱面',\n",
       "    'url': 'https://img.alicdn.com/imgextra/i4/2206698738327/O1CN01fRH3sD2BNod5geJVR_!!2206698738327-0-koubei.jpg'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050121',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '13435833720',\n",
       "  'id': 'B02F6025SL',\n",
       "  'tag': '土豆烧牛肉盖浇面,番茄牛肉汤面,葱爆羊肉盖浇面,鸡蛋凉面,老虎菜,新疆凉菜,凉拌牛肉,凉拌土豆丝,凉拌三丝,凉拌黄瓜,葱油饼加蛋',\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 09:21:39',\n",
       "  'website': [],\n",
       "  'address': '怀城镇燕城广场',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '解放中路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '兰州正宗牛肉拉面',\n",
       "  'location': '112.184188,23.912300',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F002034_314',\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFIJYKG2',\n",
       "  'distance': '71',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '13.00', 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/30122c82dee8741146abff83f23df296'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/35a46a7899d399e2405aa13a70ea0fae'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/9115b5ff1cd99aa320087748ba06c126'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '0758-5500222',\n",
       "  'id': 'B0FFKCXBMQ',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': '112.184459,23.911242',\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-23 00:21:01',\n",
       "  'website': [],\n",
       "  'address': '怀城镇解放中路67号(即步行街口)',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '旺角亭(城中新街店)',\n",
       "  'location': '112.184630,23.911255',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B02F6025XP',\n",
       "  'distance': '94',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '3.5', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '13760032159',\n",
       "  'id': 'B0HDPZJFB7',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-03-18 18:40:08',\n",
       "  'website': [],\n",
       "  'address': '红旗南路与城中路交叉路口往西南约100米',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '状元牛杂',\n",
       "  'location': '112.185282,23.911271',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFIJYKG2',\n",
       "  'distance': '107',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '12.00', 'rating': '4.5', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/41a90cb3576b863d3cab7e08c7b8896a'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0dfef0fd2c1f9c2c55d4f59fd211aecd'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/1241090c060e79869674c255dbeafd36'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619402',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '0758-5537666',\n",
       "  'id': 'B0FFFZW2H9',\n",
       "  'tag': '招牌玉米汁,鱼腐,咖哩鱼蛋,牛杂面,啪啪啪青瓜,凉拌鸡脚,玉米鲜奶,香米抹茶红豆,百香果汁,香蕉鲜奶,萝卜牛杂,红枣姜茶,招牌鸡翅,餐肉蛋三文治,爆炸牛丸',\n",
       "  'event': [],\n",
       "  'entr_location': '112.184848,23.911003',\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 09:44:24',\n",
       "  'website': [],\n",
       "  'address': '城中新街C57-58铺位',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '啖啖香',\n",
       "  'location': '112.184876,23.910957',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '140',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/1822cce0daa9d70717dec9dabafed8ff'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '13413875996',\n",
       "  'id': 'B0FFL6XUKK',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-03-19 18:30:10',\n",
       "  'website': [],\n",
       "  'address': '红旗南路怀集县人民医院西北侧',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '永发美食',\n",
       "  'location': '112.185880,23.912485',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '144',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619411',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '13929825001',\n",
       "  'id': 'B0IGCLJCH3',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-19 05:26:05',\n",
       "  'website': [],\n",
       "  'address': '怀城镇城中路71号',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '解放中路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '苏饼淮南牛肉汤',\n",
       "  'location': '112.183270,23.912188',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFL8FEHH',\n",
       "  'distance': '144',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.1', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/19e183de0f12d9b08059ef056bee03e8'},\n",
       "   {'title': [],\n",
       "    'url': 'https://img.alicdn.com/imgextra/i2/3695320962/O1CN01QseuuL1IydiF2L1Ts_!!3695320962-0-kbcontentapng.jpg'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0FFKOSDRM',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-18 09:59:57',\n",
       "  'website': [],\n",
       "  'address': '怀城镇顺景大厦',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '202',\n",
       "  'exit_location': [],\n",
       "  'name': '信记食坊',\n",
       "  'location': '112.185600,23.912866',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFIJYKG2',\n",
       "  'distance': '145',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/0d162d692e852a9f71bc4f4943cb59cd'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619402',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18742469937',\n",
       "  'id': 'B0GUBBM627',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-14 15:19:42',\n",
       "  'website': [],\n",
       "  'address': '怀城街道解放中路62号左起第9卡',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '麻辣香一城',\n",
       "  'location': '112.184551,23.910598',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '145',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '9.00', 'rating': '4.1', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/92cbbce98b5418ae3e2cf8ff58e643e1'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B02F6025W8',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-20 18:55:39',\n",
       "  'website': [],\n",
       "  'address': '红旗南路139号人民医院旁',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '红云小食店',\n",
       "  'location': '112.186006,23.911481',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F002034_460',\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFIJYKG2',\n",
       "  'distance': '146',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '17.00', 'rating': '4.0', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;火锅店',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/d96b60c54ee1d605610faf183865442c'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/c91785c182b91123e72887810dabc829'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/d38456662efe79728723c711efc0af14'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619402',\n",
       "  'typecode': '050117',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18998599166;15521307698',\n",
       "  'id': 'B0G2N74JED',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 03:31:06',\n",
       "  'website': [],\n",
       "  'address': '怀城镇解放中路67号(即城中新街)自编号首层D15单元一楼',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '布依炀骨汤麻辣烫',\n",
       "  'location': '112.184580,23.910587',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFIJYKG2',\n",
       "  'distance': '158',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '24.00', 'rating': '4.5', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;休闲餐饮场所;休闲餐饮场所|餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/8dace0de854decfe387bb63e2b8b96eb'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/20900a512a7e7609740ae8124be439d3'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/38cda9b10260c240d418f4ab928f3703'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619402',\n",
       "  'typecode': '050400|050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '0758-5875116;0758-5875186',\n",
       "  'id': 'B02F60OS0T',\n",
       "  'tag': '特级牛扒饭,扒类,港式地道奶茶,鱼蛋,滋味豉油鸡饭,蛋炒饭,咖喱牛腩,鸡扒,鸡翅,干锅类,两人木桶饭,焗饭,还有意式泡沫咖啡,鱼柳焗饭,金桔柠檬柚子蜜',\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 00:47:39',\n",
       "  'website': [],\n",
       "  'address': '怀城镇商业步行街C17卡',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '解放中路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '兄弟商品休闲餐厅',\n",
       "  'location': '112.183864,23.910676',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F002034_3125',\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B0FFIJYKG2',\n",
       "  'distance': '158',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '12.00', 'rating': '3.9', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/690de782d30e4453ff2afc951b322952'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619402',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B02F600159',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-20 22:31:50',\n",
       "  'website': [],\n",
       "  'address': '怀城镇红旗路139号',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '解放中路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '不二碗(商业步行街店)',\n",
       "  'location': '112.183418,23.911036',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F002034_242',\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': 'B02F6025XP',\n",
       "  'distance': '180',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': '59.00', 'rating': '4.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/5b180de2737fb94370a98815800dd70c'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619411',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '0758-5522055',\n",
       "  'id': 'B0GKH732MR',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-22 21:08:59',\n",
       "  'website': [],\n",
       "  'address': '城中路与国泰路交叉口东约160米',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '解放中路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': '324',\n",
       "  'exit_location': [],\n",
       "  'name': '小爱桃花源复合式餐厅(怀集店)',\n",
       "  'location': '112.182914,23.912200',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '183',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '3.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/f9bcc004d5336e221ea513a5004d21e8'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '1',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0HD0MWR9S',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-03-17 11:09:08',\n",
       "  'website': [],\n",
       "  'address': '工业大道107号A卡住改商',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '潮汕猪杂汤粉世家',\n",
       "  'location': '112.184723,23.913543',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '185',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '3.9', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/441132a41cbfd6e6acb4bafa5cdb835f'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '13435817075',\n",
       "  'id': 'B0GRDXM19L',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-03-18 23:45:18',\n",
       "  'website': [],\n",
       "  'address': '怀城镇工业大道14号(住改商)',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '亿记美食',\n",
       "  'location': '112.184993,23.913538',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '186',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '3.8', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/d13f62eceacfe1d52f6e852459b99e81'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '18813891604',\n",
       "  'id': 'B0G17CXP0T',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-22 15:36:36',\n",
       "  'website': [],\n",
       "  'address': '工业大道怀集县教育幼儿园(分园)北侧约100米',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '锐华大排档',\n",
       "  'location': '112.185045,23.913537',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '189',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '4.1', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': '13827570997',\n",
       "  'id': 'B0H3HAWJUT',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-20 06:06:37',\n",
       "  'website': [],\n",
       "  'address': '怀城街道红旗南路229号',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '老蛳好螺蛳粉',\n",
       "  'location': '112.185928,23.913144',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': [],\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '191',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': '3.6', 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '餐饮服务;中餐厅;中餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/cb3760aaecb71b3d7d52d85b2ac1b83e'},\n",
       "   {'title': [],\n",
       "    'url': 'https://img.alicdn.com/imgextra/i2/3695320962/O1CN01ROQjAD1IydiEVZBJV_!!3695320962-0-kbcontentapng.jpg'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619412',\n",
       "  'typecode': '050100',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B0FFIW6O1D',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-03-21 23:11:29',\n",
       "  'website': [],\n",
       "  'address': '怀城镇工业大道100号明珠花园A01商铺',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': 'diner',\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '红旗南路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '心味秘制螺蛳粉(明珠花园店)',\n",
       "  'location': '112.185891,23.913199',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F002034_4531',\n",
       "  'groupbuy_num': '0'},\n",
       " {'parent': [],\n",
       "  'distance': '193',\n",
       "  'pcode': '440000',\n",
       "  'importance': [],\n",
       "  'biz_ext': {'cost': [], 'rating': [], 'meal_ordering': '0'},\n",
       "  'recommend': '0',\n",
       "  'type': '公司企业;公司;网络科技|餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "  'photos': [{'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/fbc00fd493c62aa68199bc422f699c8e'},\n",
       "   {'title': [],\n",
       "    'url': 'http://store.is.autonavi.com/showpic/55c04ed4a310b481e0441ce3'}],\n",
       "  'discount_num': '0',\n",
       "  'gridcode': '3512619411',\n",
       "  'typecode': '170206|050118',\n",
       "  'shopinfo': '0',\n",
       "  'poiweight': [],\n",
       "  'citycode': '0758',\n",
       "  'adname': '怀集县',\n",
       "  'children': [],\n",
       "  'alias': [],\n",
       "  'tel': [],\n",
       "  'id': 'B02F60PT53',\n",
       "  'tag': [],\n",
       "  'event': [],\n",
       "  'entr_location': [],\n",
       "  'indoor_map': '0',\n",
       "  'email': [],\n",
       "  'timestamp': '2022-04-26 08:09:12',\n",
       "  'website': [],\n",
       "  'address': '怀城镇工业大道旧图书馆首层商店',\n",
       "  'adcode': '441224',\n",
       "  'pname': '广东省',\n",
       "  'biz_type': [],\n",
       "  'cityname': '肇庆市',\n",
       "  'postcode': [],\n",
       "  'match': '0',\n",
       "  'business_area': '解放中路',\n",
       "  'indoor_data': {'cmsid': [], 'truefloor': [], 'cpid': [], 'floor': []},\n",
       "  'childtype': [],\n",
       "  'exit_location': [],\n",
       "  'name': '阿里巴巴(城中路店)',\n",
       "  'location': '112.182770,23.912176',\n",
       "  'shopid': [],\n",
       "  'navi_poiid': 'F49F002034_2823',\n",
       "  'groupbuy_num': '0'}]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "location=\"112.184652,23.911899\"\n",
    "food_poi(location)[\"pois\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "7224655d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "112d28e7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1', 'info': 'OK', 'infocode': '10000', 'pois': [], 'count': '0'}"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "ea9f0a38",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "3bcbd0aa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>distance</th>\n",
       "      <th>pcode</th>\n",
       "      <th>importance</th>\n",
       "      <th>recommend</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>discount_num</th>\n",
       "      <th>gridcode</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>shopid</th>\n",
       "      <th>navi_poiid</th>\n",
       "      <th>groupbuy_num</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "      <th>indoor_data.cmsid</th>\n",
       "      <th>indoor_data.truefloor</th>\n",
       "      <th>indoor_data.cpid</th>\n",
       "      <th>indoor_data.floor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>34</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;四川菜(川菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050102</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>39</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>47</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[]</td>\n",
       "      <td>52</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[]</td>\n",
       "      <td>54</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F002034_4244</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B0FFIJYKG2</td>\n",
       "      <td>63</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>16.00</td>\n",
       "      <td>4.3</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>64</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;清真菜馆</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050121</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F002034_314</td>\n",
       "      <td>0</td>\n",
       "      <td>13.00</td>\n",
       "      <td>4.3</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B0FFIJYKG2</td>\n",
       "      <td>71</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>13.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B02F6025XP</td>\n",
       "      <td>94</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B0FFIJYKG2</td>\n",
       "      <td>107</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619402</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>12.00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[]</td>\n",
       "      <td>140</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[]</td>\n",
       "      <td>144</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619411</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B0FFL8FEHH</td>\n",
       "      <td>144</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B0FFIJYKG2</td>\n",
       "      <td>145</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619402</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[]</td>\n",
       "      <td>145</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F002034_460</td>\n",
       "      <td>0</td>\n",
       "      <td>9.00</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B0FFIJYKG2</td>\n",
       "      <td>146</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;火锅店</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619402</td>\n",
       "      <td>050117</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>17.00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B0FFIJYKG2</td>\n",
       "      <td>158</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;休闲餐饮场所;休闲餐饮场所|餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619402</td>\n",
       "      <td>050400|050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F002034_3125</td>\n",
       "      <td>0</td>\n",
       "      <td>24.00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B0FFIJYKG2</td>\n",
       "      <td>158</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619402</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F002034_242</td>\n",
       "      <td>0</td>\n",
       "      <td>12.00</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B02F6025XP</td>\n",
       "      <td>180</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619411</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>59.00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[]</td>\n",
       "      <td>183</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>[]</td>\n",
       "      <td>185</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>[]</td>\n",
       "      <td>186</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>[]</td>\n",
       "      <td>189</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>[]</td>\n",
       "      <td>191</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619412</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F002034_4531</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.6</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>[]</td>\n",
       "      <td>193</td>\n",
       "      <td>440000</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>公司企业;公司;网络科技|餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>0</td>\n",
       "      <td>3512619411</td>\n",
       "      <td>170206|050118</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>F49F002034_2823</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        parent distance   pcode importance recommend  \\\n",
       "0           []       34  440000         []         0   \n",
       "1           []       39  440000         []         0   \n",
       "2           []       47  440000         []         0   \n",
       "3           []       52  440000         []         0   \n",
       "4           []       54  440000         []         0   \n",
       "5   B0FFIJYKG2       63  440000         []         0   \n",
       "6           []       64  440000         []         0   \n",
       "7   B0FFIJYKG2       71  440000         []         0   \n",
       "8   B02F6025XP       94  440000         []         0   \n",
       "9   B0FFIJYKG2      107  440000         []         0   \n",
       "10          []      140  440000         []         0   \n",
       "11          []      144  440000         []         0   \n",
       "12  B0FFL8FEHH      144  440000         []         0   \n",
       "13  B0FFIJYKG2      145  440000         []         0   \n",
       "14          []      145  440000         []         0   \n",
       "15  B0FFIJYKG2      146  440000         []         0   \n",
       "16  B0FFIJYKG2      158  440000         []         0   \n",
       "17  B0FFIJYKG2      158  440000         []         0   \n",
       "18  B02F6025XP      180  440000         []         0   \n",
       "19          []      183  440000         []         0   \n",
       "20          []      185  440000         []         0   \n",
       "21          []      186  440000         []         0   \n",
       "22          []      189  440000         []         0   \n",
       "23          []      191  440000         []         0   \n",
       "24          []      193  440000         []         0   \n",
       "\n",
       "                               type  \\\n",
       "0                  餐饮服务;中餐厅;四川菜(川菜)   \n",
       "1                      餐饮服务;中餐厅;中餐厅   \n",
       "2                      餐饮服务;中餐厅;中餐厅   \n",
       "3                      餐饮服务;中餐厅;中餐厅   \n",
       "4                      餐饮服务;中餐厅;中餐厅   \n",
       "5                      餐饮服务;中餐厅;中餐厅   \n",
       "6                     餐饮服务;中餐厅;清真菜馆   \n",
       "7                      餐饮服务;中餐厅;中餐厅   \n",
       "8                      餐饮服务;中餐厅;中餐厅   \n",
       "9                      餐饮服务;中餐厅;中餐厅   \n",
       "10                     餐饮服务;中餐厅;中餐厅   \n",
       "11                     餐饮服务;中餐厅;中餐厅   \n",
       "12                     餐饮服务;中餐厅;中餐厅   \n",
       "13                     餐饮服务;中餐厅;中餐厅   \n",
       "14                     餐饮服务;中餐厅;中餐厅   \n",
       "15                     餐饮服务;中餐厅;火锅店   \n",
       "16  餐饮服务;休闲餐饮场所;休闲餐饮场所|餐饮服务;中餐厅;中餐厅   \n",
       "17                     餐饮服务;中餐厅;中餐厅   \n",
       "18                     餐饮服务;中餐厅;中餐厅   \n",
       "19                     餐饮服务;中餐厅;中餐厅   \n",
       "20                     餐饮服务;中餐厅;中餐厅   \n",
       "21                     餐饮服务;中餐厅;中餐厅   \n",
       "22                     餐饮服务;中餐厅;中餐厅   \n",
       "23                     餐饮服务;中餐厅;中餐厅   \n",
       "24  公司企业;公司;网络科技|餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "\n",
       "                                               photos discount_num  \\\n",
       "0   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "1                                                  []            0   \n",
       "2                                                  []            0   \n",
       "3                                                  []            0   \n",
       "4   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "5   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "6   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "7   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "8                                                  []            0   \n",
       "9   [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "10  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "11                                                 []            0   \n",
       "12  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "13  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "14  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "15  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "16  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "17  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "18  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "19  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "20  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "21  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "22                                                 []            0   \n",
       "23  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "24  [{'title': [], 'url': 'http://store.is.autonav...            0   \n",
       "\n",
       "      gridcode       typecode  ... shopid       navi_poiid groupbuy_num  \\\n",
       "0   3512619412         050102  ...     []               []            0   \n",
       "1   3512619412         050100  ...     []               []            0   \n",
       "2   3512619412         050100  ...     []               []            0   \n",
       "3   3512619412         050100  ...     []               []            0   \n",
       "4   3512619412         050100  ...     []  F49F002034_4244            0   \n",
       "5   3512619412         050100  ...     []               []            0   \n",
       "6   3512619412         050121  ...     []   F49F002034_314            0   \n",
       "7   3512619412         050100  ...     []               []            0   \n",
       "8   3512619412         050100  ...     []               []            0   \n",
       "9   3512619402         050100  ...     []               []            0   \n",
       "10  3512619412         050100  ...     []               []            0   \n",
       "11  3512619411         050100  ...     []               []            0   \n",
       "12  3512619412         050100  ...     []               []            0   \n",
       "13  3512619402         050100  ...     []               []            0   \n",
       "14  3512619412         050100  ...     []   F49F002034_460            0   \n",
       "15  3512619402         050117  ...     []               []            0   \n",
       "16  3512619402  050400|050100  ...     []  F49F002034_3125            0   \n",
       "17  3512619402         050100  ...     []   F49F002034_242            0   \n",
       "18  3512619411         050100  ...     []               []            0   \n",
       "19  3512619412         050100  ...     []               []            0   \n",
       "20  3512619412         050100  ...     []               []            0   \n",
       "21  3512619412         050100  ...     []               []            0   \n",
       "22  3512619412         050100  ...     []               []            0   \n",
       "23  3512619412         050100  ...     []  F49F002034_4531            0   \n",
       "24  3512619411  170206|050118  ...     []  F49F002034_2823            0   \n",
       "\n",
       "   biz_ext.cost biz_ext.rating biz_ext.meal_ordering indoor_data.cmsid  \\\n",
       "0            []            3.6                     0                []   \n",
       "1            []             []                     0                []   \n",
       "2            []            4.0                     0                []   \n",
       "3            []             []                     0                []   \n",
       "4            []            4.0                     0                []   \n",
       "5         16.00            4.3                     0                []   \n",
       "6         13.00            4.3                     0                []   \n",
       "7         13.00            4.0                     0                []   \n",
       "8            []            3.5                     0                []   \n",
       "9         12.00            4.5                     0                []   \n",
       "10           []             []                     0                []   \n",
       "11           []            4.0                     0                []   \n",
       "12           []            4.1                     0                []   \n",
       "13           []             []                     0                []   \n",
       "14         9.00            4.1                     0                []   \n",
       "15        17.00            4.0                     0                []   \n",
       "16        24.00            4.5                     0                []   \n",
       "17        12.00            3.9                     0                []   \n",
       "18        59.00            4.6                     0                []   \n",
       "19           []            3.6                     0                []   \n",
       "20           []            3.9                     0                []   \n",
       "21           []            3.8                     0                []   \n",
       "22           []            4.1                     0                []   \n",
       "23           []            3.6                     0                []   \n",
       "24           []             []                     0                []   \n",
       "\n",
       "   indoor_data.truefloor indoor_data.cpid indoor_data.floor  \n",
       "0                     []               []                []  \n",
       "1                     []               []                []  \n",
       "2                     []               []                []  \n",
       "3                     []               []                []  \n",
       "4                     []               []                []  \n",
       "5                     []               []                []  \n",
       "6                     []               []                []  \n",
       "7                     []               []                []  \n",
       "8                     []               []                []  \n",
       "9                     []               []                []  \n",
       "10                    []               []                []  \n",
       "11                    []               []                []  \n",
       "12                    []               []                []  \n",
       "13                    []               []                []  \n",
       "14                    []               []                []  \n",
       "15                    []               []                []  \n",
       "16                    []               []                []  \n",
       "17                    []               []                []  \n",
       "18                    []               []                []  \n",
       "19                    []               []                []  \n",
       "20                    []               []                []  \n",
       "21                    []               []                []  \n",
       "22                    []               []                []  \n",
       "23                    []               []                []  \n",
       "24                    []               []                []  \n",
       "\n",
       "[25 rows x 47 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(food_poi(location)[\"pois\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "31f48876",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
